2014-09-18-10735.2600 Spec - Standard UPC for Japan & Korea UPCchange #SDLABELREPORTS #ABAPUPC

SPECIFICATIONS

10735.2600 -Spec- Standard UPC for Japan & Korea UPCchange


Purpose

New UPC label L97,S31 should be created for Japan and Update the Korea label string sequence changes for L26 S28/S34 labels

Admin Info

Purpose
 New UPC label L97,S31 should be created for Japan and Update the Korea
label string sequence changes for L26 S28/S34 labels
Requested By
 Lizz Paxson
Spec Created By
 Deepak Yasam
Spec Created Date
 09/18/2014
Spec QA by
 Deepak Yasam
Objects
 ZRSD_UPC_LABELS
Document Status
 WIP


Estimates


Sl.No
 Activity
 Estimation in Hours
1
 Research
 00
2
 Documentation
 02
3
 Development/ Config
 08
4
 Unit test in DEV
 02
5
 Unit test in QUA
 02
6
 Other activity

TOTAL
 14

References

Prior Tickets

[Provide links of prior associated Spec / Break Fix BOSS document(s)]



Documents

[Attach any document(s) received for the requirement(s)]




Spec Changes

[List the changes made to program after the approval of the original requirement along with the Date on which the change request was received and the name of the initiator]

Sl.
 Change Details
 Requested By
 Requested On
 Notes if any
1
 Update the Korea label string sequence changes for L26 S28/S34 labels
 Lizz Paxson
 10/02/2014
 N/A
2
 Split the ZMRP price for JPY currency into two varaibles
 Lizz Paxson
 10/17/2014
 N/A















Functional Requirement

Purpose/WHY:

[Explain the purpose of the project and the reason why this requirement has come]
New UPC label L97 should be created to use with S31 for Japan and Korea label string sequence changes for L26 S28/S34 labels.
Split the ZMRP price for JPY currency into two varaibles

In Scope:

[List the activities to be included in scope]
The label L97 would be used with S31.
The ZMRP would be printed as two variables only for JPY currency.

Out of Scope:

[Out of scope activities]
The new label L97 cannot be used with S codes other than S31

Solution Summary

[Discuss this section with Requester and get approval prior to beginning work]

Add new L code L97 label to be used with S31 S code for the UPC label printing.
L97 - standardUPCjapan.lwl

Below is the string sequence for the S code:

S31-> Material(NE_SKU), MSRP_price, UPC, Description, Quantity


Update the Korea label string sequence changes for L26 S28/S34 labels.
L26 - KR_UPC_EAN13.LWL
S28 - NE material number, Description, Size, Year, Month, Cust_retail_price, UPC, Quantity
S34 - NE material number, Description, Size, Year, Month, MSRP_price, UPC, Quantity

ZMRP Split for JPY:

Price 1 field before the comma, price 2 after the comma. This way no matter what the pricing whether its single digit or double it will print. This would take care of the comma as delimiter if price was considered 2 fields.

For Ex - 2,000
50,000

1) msrp1 = if number is greater than 999, then start at position 4 from the right and moving left, grab all the characters. If number is less than 1000, send no value but include the comma to indicate blank field data
msrp2 = starting at right position and moving left grab up to 3 characters

Below are some examples:
example1 data
material = 1004753, price = 45000, UPC = 895671235968, description = NEYYAN BLUE
string output = 1004753,45,000,895671235968,NEYYAN BLUE

example2 data
material = 1004754, price = 950, UPC = 895671235969, description = NEYYAN GREEN
string output = 1004754,,950,895671235969,NEYYAN GREEN

example3 data
material = 1004755, price = 8500600, UPC = 895671235970, description = NEYYAN RED
string output = 1004755,8500,600,895671235970,NEYYAN RED


Test Plan

[List test scenarios/cases to be executed here]
S.no
 Test Scenario
 Expected Results
1
 Create a SO with 3200,10,00 sales area with L97,S31 VAS codes and save the order.Execute the SO in ZSD_UPCLBL t.code in the sales order input.
 The desired label should be printed in the output and the ZMRP price is printed without any decimals .
2
 Create a SO with 3100,10,00 sales area with L26,S28 VAS codes and save the order.Execute the SO in ZSD_UPCLBL t.code in the sales order input.
 The desired label should be printed in the output with the new string sequence.
3
 Create a SO with 3100,10,00 sales area with L26,S34 VAS codes and save the order.Execute the SO in ZSD_UPCLBL t.code in the sales order input.
 The desired label should be printed in the output with the new string sequence.

ZMRP Split:


Test ID
 Test Scenario
 Expected Results
SD-001
 For Stock items:
Execute ZSD_UPCLBL t.code with the below inputs.
Material,size,qty,S.org,cur,MSRP
 The desired string label should be printed and ZMRP value should get split as expected for L97,S31.
SD-002
 For Stock items:
Create a Purchase order and execute in ZSD_UPCLBL T.code under UPC(stock items only)
 The desired string label should be printed and ZMRP value should get split as expected for L97,S31.
SD-003
 For Customer specific labels:
Create a SO and execute in ZSD_UPCLBL T.code under customer specific labels
 The desired string label should be printed and ZMRP value should get split as expected for L97,S31.
SD-004
 For Customer specific labels:
Create a SO and execute in ZSD_UPCLBL T.code under customer specific labels with below inputs.
SO number,material number from the SO,size,qty
 The desired string label should be printed for the given material and ZMRP value should get split as expected for L97,S31.
SD-005
 For Customer specific labels:
Execute ZSD_UPCLBL t.code with the below inputs.
S.org,Cust,Material,size,Qty
 The desired string label should be printed and ZMRP value should get split as expected for L97,S31.

Solution Details

1) Added the New L-Code 'L97' to be used for S-Code 'S31' String and also
2) Update the New String Fields for L-code L26 ,S-Codes 'S28' & 'S34' Strings.

Issues

[List Issues / Bugs identified in configuration or development]